﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace DALScolarite 
{
    public partial class scolarite_eltdiplome
    {
        uvtmoyEntities ent;
        public List<scolarite_eltdiplome> diplome()
        {
            ent = new uvtmoyEntities();
            var query = (from s in ent.scolarite_eltdiplome
                        where  !(from s2 in ent.scolarite_eltdiplome select s2.idPereEltDiplome).Contains(s.idEltDiplome)
                        select s);
            if (query.Any())
            {

                return query.ToList();
            }
            else
            {
                return null;
            }
        }
    }
}
